<%-- 
    Document   : DeleteManufacturer
    Created on : 2009-3-25, 14:51:16
    Author     : LIUGeorge
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language="java" import="java.sql.*, java.io.*, java.util.*, database.*" %>
<jsp:useBean id="con" class="database.DatabaseConnection"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Delete Manufacturer</title>
    </head>
    <style type="text/css">
        <!--
        body {
            background-image: url(../../image/3110_background/backcolor3.jpg);
            background-repeat: repeat;
        }
        .STYLE1 {font-size: 14px}
        .STYLE2 {color: #FF0000}
        -->
    </style>

    <body>
        <table width="970" border="0">
            <tr>
                <td align="left" scope="col"><span class="STYLE1">Your Location: <a href="Homepage2.html" target="_blank">Home Page</a>&gt;&gt;<a href="ManufacturerManager.jsp">Manufacturer Manager</a>&gt;&gt;Delete Manufacturer</span></td>
            </tr>
        </table>
        <p>&nbsp;</p>
        <form>
            <table width="925" border="1" align="center">
                <tr>
                    <td width="333" align="center" valign="middle">Manufacture Name</td>
                    <td width="194" align="center" valign="middle">Manager</td>
                    <td width="250" align="center" valign="middle">Telephone</td>
                    <td colspan="2" align="center" valign="middle">Action</td>
                </tr>
                <%
        con.createConnection();
        ResultSet rs = con.getManu();
        String The_ID = null;
        String Manufacturer_Information_Name = null;
        String Manufacturer_Information_Manager = null;
        String Manufacturer_Information_Telephone = null;

                    for (int j = 0; j < 8; j++) {
                        if (rs.next()) {
                            The_ID = rs.getString("Manufacturer_Information_ID");
                            Manufacturer_Information_Name = rs.getString("Manufacturer_Information_Name");
                            Manufacturer_Information_Manager = rs.getString("Manufacturer_Information_Manager");
                            Manufacturer_Information_Telephone = rs.getString("Manufacturer_Information_Telephone");
                    %>
                    <tr align="left" valign="top">
                    <td align="center" valign="middle"><%=Manufacturer_Information_Name%></td>
                    <td align="center" valign="middle"><%=Manufacturer_Information_Manager%></td>
                    <td align="center" valign="middle"><%=Manufacturer_Information_Telephone%></td>
                    <td colspan="2" align="center" valign="middle"><input type="button" value="Delete" target="mainFrame" onClick="window.location.href='DeleteMF.jsp?TF=0&ID=<%=The_ID%>'"></td>
                    </tr>
                    <%
                        }
                    }
                    %>
                <tr>
                    <td colspan="3" align="center" valign="middle">&nbsp;</td>
                    <td width="56" align="center" valign="middle">Back</td>
                    <td width="58" align="center" valign="middle">Next</td>
                </tr>
            </table>
            <p>&nbsp;</p>
        </form>
    </body>
</html>
